CREATE PROC [dbo].[GetInfo]
    @AutoID VARCHAR(10),
    @Database VARCHAR(5),
    @Code VARCHAR(100),
    @Qty VARCHAR(50),
    @Anbar VARCHAR(5),
    @Sender VARCHAR(5) = '0',
    @User VARCHAR(3),
    @Row VARCHAR(3) = NULL,
    @Qty2 VARCHAR(6) = '0'
	
    
AS
DECLARE @K_codeTmp INT;
DECLARE @executecommand VARCHAR(MAX);
DECLARE @SQLString NVARCHAR(MAX);
SET @Code = REPLACE(@Code,'','')
IF LEN(@Code) >= 53
SET @Code = SUBSTRING(@Code,4,13)

SET @SQLString
    = N'select  @GoodsCode = k_code from [' + @Database + N'].[dbo].[TblBasket_Kala] where (K_Code_B = @InputCode)';
EXECUTE sp_executesql @SQLString,
                      N'@InputCode Varchar(15) ,  @GoodsCode varchar(15) OUTPUT',
                      @InputCode = @Code,
                      @GoodsCode = @Code OUTPUT;


IF EXISTS
(
    SELECT 1
    FROM dbo.tblPda
    WHERE AutoID = @AutoID
          AND A_Code = @Anbar
          AND
          (
              K_Code = @Code
              OR Barcode = @Code
          )
)
BEGIN

    RETURN 1;
END

ELSE
BEGIN
    SET @executecommand
        = 'INSERT INTO tblpda (AutoID,K_Code,Barcode ,K_Qty,A_Code,Status,Name1,Price_Kharid,Price_Forosh,Price_Omdeh,Sender,Row,Qty2)
Select ''' + @AutoID + ''', G.K_Code , G.Barcode , ''' + @Qty + ''' , ''' + @Anbar
          + ''',''10'', G.Name1 ,   W.Price_Kharid , W.Price_Forosh ,W.Price_Omdeh ,''' + @Sender + ''', ''' + @Row
          + ''' ,'''+@Qty2+'''
		 
From  [' + @Database + '].[dbo].[KalaId] G
Join [' + @Database + '].[dbo].[Anbar] W On W.A_Code = ''' + @Anbar
          + ''' and W.K_Code = G.K_Code
WHERE ( G.K_Code = ''' + @Code + ''' ) OR (G.Barcode = ''' + @Code + ''')';

    --PRINT @executecommand;
	
    EXEC (@executecommand);

END;